MS SQL
MS SQL
In this article we will learn to fetch the numbers of rows in ms sql database table.
Some time in situations where we require the count of the rows in each table, we can go with various approach like using third party software, count manually :-( or write program in our preferred language.
In this article we will see how to get the first and last date of previous month. This is very helpful to generate the previous month reports.
In this article, we will learn to take the backup of MS SQL database with password protected. Password protected files are very secured since unauthorized person will not able to access it. If it is database then it is more important to secured the database backup file with password.
Binary format is very difficult to read. Suppose you get task to replace the some text of for field whose datatype is image or varbinary. We can achieve the task in different different way.